Expert system for data migration between different database management systems
نویسندگان
چکیده
This paper deals with the design of the fuzzy expert system for processing data migration between different relational database management systems (RDBMS). At the beginning we identify current state of data migration between different RDBMS. Then we propose new approach which suggests creating of expert system as a tool for migration of database tables and their data between different RDBMS. The expert system contains a knowledge base which is composed of IF-THEN rules and based on the input data suggests appropriate data types of columns of database tables. The proposed tool, which contains an expert system, also includes the possibility of optimizing the data types in the target RDBMS database tables based on processed data of the source RDBMS database tables. Paper also proposes methodological guidelines for successful migration of database tables and their data between different RDBMS and suggests the possibility of tool extension when the source or target RDMBS is changed. The proposed expert system is shown on data migration of selected database of the source RDBMS to the target RDBMS. Key-Words: expert system, fuzzy, data migration, database, relational database, data type, relational database management system.
منابع مشابه
A comparison between the Kazerun (Iran) and the North Anatolian (Turkey) fault systems in fault interaction and seismicity migration based on the spatiotemporal analysis of earthquakes
The Kazerun Fault System (KFS) is a right-lateral strike slip fault system in the middle part of the Zagros seismogenic zone in Iran. Historical and instrumental earthquake data catalogs of this fault system show good evidence of fault interactions and seismic migrations. This study provides evidence for the migration of seismicity in the middle part of the Zagros region along the segments of t...
متن کاملDesigning an expert system to advise the IT students' Master's degree for course selection
In the university educational system, students, depending on their different conditions, need guidance to choose the best courses and the best curriculum during a semester. Lack of sufficient information about class hours, exam interactions, prerequisites for each course, variety of instructors and other conditions may lead to a wrong choice and confusion of students. In this research, an exper...
متن کاملAn Authorization Framework for Database Systems
Today, data plays an essential role in all levels of human life, from personal cell phones to medical, educational, military and government agencies. In such circumstances, the rate of cyber-attacks is also increasing. According to official reports, data breaches exposed 4.1 billion records in the first half of 2019. An information system consists of several components, which one of the most im...
متن کاملDesign and Development of Early Warning System for Desertification and Land Degradation
Early warning systems are key components of strategies to reduce risk. This research, by adopting a systematic approach in the management of the risk of desertification and by including previously developed models and systems, offers an integrated efficient structure in terms of early warning for the risk of desertification as a pilot system for semi-arid areas of west Golestan Province in IRAN...
متن کاملA Fuzzy Expert System & Neuro-Fuzzy System Using Soft Computing For Gestational Diabetes Mellitus Diagnosis
Gestational diabetes mellitus (GDM) is a kind of diabetes that requires persistent medical care in patient self management education to prevent acute complications. One of the common and main problems in diagnosis of the diabetes is the weakness in its initial stages of the illness. This paper intends to propose an expert system in order to diagnose the risk of GDM by using FIS model. The knowl...
متن کامل